UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scJX29eRKh3ot17UYvUJWBgECkFPLaUhxnuEfeqZEAo='
WHERE
key_id = 'c84be3c2603cd82d5c06fad52204cdef4b320259f5350e20de030bbabff2d87b'
AND (
token = 'scJX29eRKh3ot17UYvUJWBgECkFPLaUhxnuEfeqZEAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)