UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hd8SSd06plfTqjNyb6Mm0VviGTgPKaPEWi6sCJfwCbc='
WHERE
key_id = '49390923ffcaf6d1d8b6c25983538968c678570f70349db54b95e7ddb012e8ec'
AND (
token = 'hd8SSd06plfTqjNyb6Mm0VviGTgPKaPEWi6sCJfwCbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)