UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9z+f7MIWvXn9vxw0t5VWlw+GJOUJ6iUSlupoCAcpAM8='
WHERE
key_id = 'bcfd71f41489897b1fa0e14c8f80a71a4a3575b6fef93e1bc2d83d7e8ea282a1'
AND (
token = '9z+f7MIWvXn9vxw0t5VWlw+GJOUJ6iUSlupoCAcpAM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)