UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F7JNYJ49LiaU4zBhn23N9iVJNNQa2tkvHl9fsvh8WWw='
WHERE
key_id = '1d6ee3cf99b6d132b972eef7a25cb8dbde4b9dd26c65840c11357f711cfb1666'
AND (
token = 'F7JNYJ49LiaU4zBhn23N9iVJNNQa2tkvHl9fsvh8WWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)