UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PPgaoty5jSKUyXk5Rou1O8M5voPXMlpQaC9iKET7h+A='
WHERE
key_id = '24858e504b409337f103fabb4c64952a02e2948217fa4b6b12732a4e799d76f3'
AND (
token = 'PPgaoty5jSKUyXk5Rou1O8M5voPXMlpQaC9iKET7h+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)