UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+w16pzgaWJtWLQb1sW2QbiJe7KLsiI4Ospsp6ak8bEc='
WHERE
key_id = '31d9002542449ff088b7a5ca75e45766d944ec720153cb473cc0e45b110386c0'
AND (
token = '+w16pzgaWJtWLQb1sW2QbiJe7KLsiI4Ospsp6ak8bEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)