UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWSc0BEhm7MPjZp9Cdf02p85OqTDalCS+ihFcknS2N4='
WHERE
key_id = '65b86d12fc5db486f0d79eeea22d55e6c1f28b73e995a8c68487545aca06f551'
AND (
token = 'aWSc0BEhm7MPjZp9Cdf02p85OqTDalCS+ihFcknS2N4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)