UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dFYsH7uH/gDJMOYbOVh7NYUAnaWDHvrLNHSKooFIJc='
WHERE
key_id = 'a6fbe0aa2d4550ae8350145e70ca532790438dfb0c4039fc299c2952126cafce'
AND (
token = '0dFYsH7uH/gDJMOYbOVh7NYUAnaWDHvrLNHSKooFIJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)