UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZqGtd/PtJOiDH814y03met3zwxK48qfii2vGYISCUA='
WHERE
key_id = '928803bab2178660feef297bd651c5d728e323cbc9adee54fb371b07ef4df346'
AND (
token = 'gZqGtd/PtJOiDH814y03met3zwxK48qfii2vGYISCUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)