UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JMP9aOoieYnpD9mm0dVYJpCIaTpMzim8HQIwFuCFdw4='
WHERE
key_id = '311302b688c4a203134f25823b6a5519c85b93cc2ffb5b4df9c5480f7a9d264c'
AND (
token = 'JMP9aOoieYnpD9mm0dVYJpCIaTpMzim8HQIwFuCFdw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)