UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C00vQ7oCiZsGy/Xw5X3UhBo5yW450cqiYprsvZzwMgA='
WHERE
key_id = '5b8b7c1784ce85705e9e47c9fc28ef96d0aa1a1468e5ec271d780d39ee797f1e'
AND (
token = 'C00vQ7oCiZsGy/Xw5X3UhBo5yW450cqiYprsvZzwMgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)