UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZnJBUsDxzo+gtrIGHOgwV5W3vkSlZy/RpLE08fiG2s='
WHERE
key_id = '22d6ebd464f0a51e3bb19398a4712c577e9348fc36e1f122ca5c35899e540e63'
AND (
token = 'gZnJBUsDxzo+gtrIGHOgwV5W3vkSlZy/RpLE08fiG2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)