UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHuWtvAGANXYqdsTVyFfDNkgE6WivuSWjCZy6f5zlf8='
WHERE
key_id = 'dad17b3e58f516604c49cfbf802c023115b10b7f877b2c1f05bac8170403d77f'
AND (
token = 'PHuWtvAGANXYqdsTVyFfDNkgE6WivuSWjCZy6f5zlf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)