UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FEi9Li9VOTiuxmmgoc6y8B4qrEX78XODY7t3UJ026K8='
WHERE
key_id = 'b71635a63a9485d64ec7c308f2d40746a0e3e5fb503e1c4a07b9f43e1d4ecb4a'
AND (
token = 'FEi9Li9VOTiuxmmgoc6y8B4qrEX78XODY7t3UJ026K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)