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