UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNJIk9ifl1BmRhL2KpsA4ZKXtEcVuaH2ukY3HhZVBZg='
WHERE
key_id = 'e5546dfb83bbd907f2622ae0164bd291c7f7f1d98a0d5c5c20d75eb0d15e3227'
AND (
token = 'fNJIk9ifl1BmRhL2KpsA4ZKXtEcVuaH2ukY3HhZVBZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)