UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zawOHQxdUrAexOZlJCoYCe4gZqyKikzMklInE8nmZBs='
WHERE
key_id = '8c20506db48d6b8fbb5270790bc083f41f71d5632e8e136c691da7819917267a'
AND (
token = 'zawOHQxdUrAexOZlJCoYCe4gZqyKikzMklInE8nmZBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)