UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lSPm0gj2h3FbuCmHjSKwgen169p4UHOnPVYBhuNx/Xg='
WHERE
key_id = 'edd30b4286ad45060d28fcab87650e76d3f321a0f01ec5710c862b192d49b858'
AND (
token = 'lSPm0gj2h3FbuCmHjSKwgen169p4UHOnPVYBhuNx/Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)