UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpcBTN+82M8d8Idqk9KmiyN8QnrG2g6AQnxWNRgo7co='
WHERE
key_id = '346d4c751d54e2f9f42a20026653d1ef581a59700008f5e04455c8bb103d8288'
AND (
token = 'hpcBTN+82M8d8Idqk9KmiyN8QnrG2g6AQnxWNRgo7co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)