UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'magf7ekrhriTfy1W3bIOSj9dZ+TYZqzroM8KJV4JBL4='
WHERE
key_id = 'a6fbd9db40132fcdcab1574e839220a33e7f7084ea38526437d5d84135e561a9'
AND (
token = 'magf7ekrhriTfy1W3bIOSj9dZ+TYZqzroM8KJV4JBL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)