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