UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foBC8xi7/ski+F0Y9kONk/hrmYfKjoPTsdu2adOeeuE='
WHERE
key_id = 'aab6910cca55919bf1d3cb4e5c4b560c279e0db26e6088da01185f695b903882'
AND (
token = 'foBC8xi7/ski+F0Y9kONk/hrmYfKjoPTsdu2adOeeuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)