UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/DsxwnEWceL3s2MKOinleKeI31tTYHgttftoOfiIij8='
WHERE
key_id = 'd119beda2bbd72bb829368a92f8647bd2ea684c0a2dc7d0d586ee6b61d67cdca'
AND (
token = '/DsxwnEWceL3s2MKOinleKeI31tTYHgttftoOfiIij8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)