UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GpAoCiCs2jzOPZ5yG/bcbzQiIHr6kmHwhNYImNWQrU='
WHERE
key_id = 'caefe1573847872d16f97f0268b402da9ddebc526f6dd054683638276977217d'
AND (
token = '1GpAoCiCs2jzOPZ5yG/bcbzQiIHr6kmHwhNYImNWQrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)