UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fbtg39bXZU+NI9+tNwwoN0ytR/cJojMtFtFi28BlkxA='
WHERE
key_id = 'f9838b74cdac68126d66b04fee8c0989ceb5bb844b75f887164ecc378b3e6c9e'
AND (
token = 'fbtg39bXZU+NI9+tNwwoN0ytR/cJojMtFtFi28BlkxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)