UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5IC50Kg4KPTBjEhxukmTeY+0BJdlU6lNBluL1GS7rT8='
WHERE
key_id = '0f78a95c93c5070826b3788440c9296b94bfc831a861b5209ab93f1ea1f9ae76'
AND (
token = '5IC50Kg4KPTBjEhxukmTeY+0BJdlU6lNBluL1GS7rT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)