UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zhx9vl/TO3k8kHBJMY7WF7A8ewkjy9AeSWM6H1qKhn8='
WHERE
key_id = '42a39ee0d946f2e9586740deb9dd21f42fe695434b435e08a60f56ec58a401ab'
AND (
token = 'Zhx9vl/TO3k8kHBJMY7WF7A8ewkjy9AeSWM6H1qKhn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)