UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKaQGEr73SIOJUYZk2fwgTDtT3Fx1tU+WGugTx/z6lk='
WHERE
key_id = 'd78743b12a56c2130d6597dce0bb65b660884142540d0a635a48d34b497a4446'
AND (
token = 'LKaQGEr73SIOJUYZk2fwgTDtT3Fx1tU+WGugTx/z6lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)