UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qZMk0iWKbBigVzMO6M523fIB70JjWEEIdXYm8+u9HI='
WHERE
key_id = '0997cdd774c830befe6e2191ca0fbd9f4a79b52f69059d7ce0d52053e8aa4fe7'
AND (
token = '8qZMk0iWKbBigVzMO6M523fIB70JjWEEIdXYm8+u9HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)