UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q6s7i5xEAf548HwrgedUVPw58GgXpvczeqbihmb/ubI='
WHERE
key_id = '1c97a94191d0f9eb8bb2e73b1f4a5fe941c97a18335a6207f0f9fc6bf8ee77e0'
AND (
token = 'Q6s7i5xEAf548HwrgedUVPw58GgXpvczeqbihmb/ubI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)