UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEyXfkZCg2JNjXvrq6p3mkRnwkltSfgD3n8zsIouI+E='
WHERE
key_id = 'acfb25e4b1d10c2b62f2fd58a97ffff3b02c93e935486662da6f182dcd008edf'
AND (
token = 'pEyXfkZCg2JNjXvrq6p3mkRnwkltSfgD3n8zsIouI+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)