UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfLpQtMdCn7s4yVgDXJfBE6fu1OLTB0So0tgNzCiI+M='
WHERE
key_id = '8ddcf7cd11e2bd52b62721565388b85a8765e62110cf18ab76958e5a0e776f8f'
AND (
token = 'OfLpQtMdCn7s4yVgDXJfBE6fu1OLTB0So0tgNzCiI+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)