UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SMurPbzLyD5UliDyhxrjEnYvEHacit3/JUbvXh3XVY='
WHERE
key_id = '78a23acf00c31a83136b74bce7bbb644c2a6b95223d42944f7606b9b7661afb0'
AND (
token = '8SMurPbzLyD5UliDyhxrjEnYvEHacit3/JUbvXh3XVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)