UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/KzQEkVo7ilrSzi+bw0yTNo3Ufhf614Blg5SEHpMvI='
WHERE
key_id = 'a407022f15aaced8d1a19c0eb651f35d79850a5a40df04c1289a7449b28ed90f'
AND (
token = 'd/KzQEkVo7ilrSzi+bw0yTNo3Ufhf614Blg5SEHpMvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)